Gen Report Date: 2024-07-18

Years: 2021, 2022, 2023

Channels: MNG, WTC

Measures: Product Revenue($), Product Qty(#)

1 ) Product Revenue KPI

2 ) Channel

2.1 Product Revenue Trend

2.2 Product Revenue Portfolio

2.3 Product Revenue Portfolio Distribution

3 ) Brand

3.1 Product Revenue Trend

3.1.1 Total: MNG + WTC

3.1.2 MNG

3.1.3 WTC

3.2 Product Revenue Portfolio

3.2.1 Total: MNG + WTC

3.2.2 MNG

3.2.3 WTC

3.3 Product Revenue Portfolio Distribution

3.3.1 Total: MNG + WTC

3.3.2 MNG

3.3.3 WTC

3.4 Product Revenue and Qty

4 ) Product

4.1 Product Revenue Portfolio Distribution

4.2 Top 80% Revenue

4.2.1 Total: MNG + WTC

4.2.2 MNG

4.2.3 WTC

4.3 Product Revenue and Qty

4.4 Correlation Product Revenue

5 ) Appendix

Data Summary Description

Data : Scan Sales Report (MNG and WTC)

Dimensions: 3429 x 17
Duplicates: 0
No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 CHANNEL [character]
1. MNG
2. WTC
1321(38.5%)
2108(61.5%)
 0 (0.0%)
2 ITEMID [character]
1. DCATA040BTHK02
2. DLBSC120BXHK01
3. DLJSC120BXHK01
4. FDC02014
5. FDC07016
6. FDC45016
7. FGB016
8. FHP013
9. FHP013TWFJT01C
10. FIS014
[ 73 others ]
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
2809(81.9%)
 0 (0.0%)
3 DATE [Date]
min : 2021-01-01
med : 2022-04-01
max : 2023-07-01
range : 2y 6m 0d
 31 distinct values 0 (0.0%)
4 PROD_REV [numeric]
Mean (sd) : 59743.7 (145688.5)
min ≤ med ≤ max:
-59.7 ≤ 1674.4 ≤ 1650000
IQR (CV) : 51802.1 (2.4)
 1489 distinct values 0 (0.0%)
5 PROD_QTY [numeric]
Mean (sd) : 845.7 (5225.7)
min ≤ med ≤ max:
-1 ≤ 0 ≤ 130148
IQR (CV) : 451 (6.2)
 1081 distinct values 0 (0.0%)
6 DATAAREAID [character] 1. vghp
3410(100.0%)
 19 (0.6%)
7 PRODUCTTYPE [character] 1. 1
3410(100.0%)
 19 (0.6%)
8 ITEMGROUPID [character]
1. DC
2. LZ
3. VH
4. YY
5. DCJ
6. HP
7. IS
8. JT
9. YZ
10. GB
[ 20 others ]
1023(30.0%)
341(10.0%)
279(8.2%)
186(5.5%)
155(4.5%)
124(3.6%)
124(3.6%)
124(3.6%)
124(3.6%)
62(1.8%)
868(25.5%)
 19 (0.6%)
9 Company [character] 1. VGHP
3410(100.0%)
 19 (0.6%)
10 Brand [factor]
1. VG
2. VH
3. DC
4. NV
5. WATON
1612(47.3%)
341(10.0%)
1271(37.3%)
124(3.6%)
62(1.8%)
 19 (0.6%)
11 SubBrand [character]
1. Functions
2. JointsAndBones
3. LZ
4. Vitamins
5. VH
6. YY
7. HP
8. IS
9. YZ
10. VC
[ 16 others ]
496(15.1%)
434(13.2%)
403(12.3%)
341(10.4%)
217(6.6%)
186(5.7%)
124(3.8%)
124(3.8%)
124(3.8%)
93(2.8%)
744(22.6%)
 143 (4.2%)
12 ProductCategoryName [character]
1. Capsule
2. Chewable
3. Foot Patch
4. Honey
5. Sachet
6. Shampoo
7. Softgel
8. Spray
9. Tablet
10. Tonic
1674(55.7%)
31(1.0%)
62(2.1%)
62(2.1%)
155(5.2%)
31(1.0%)
341(11.3%)
31(1.0%)
589(19.6%)
31(1.0%)
 422 (12.3%)
13 ProductSubCategoryName [character] 1. Finished Goods
2976(100.0%)
 453 (13.2%)
14 ProductSubCategoryID [character]
1. VG_DC_JNB_SOF_FG
2. VG_DC_VTM_TAB_FG
3. VG_VG_LZ_CAP_FG
4. VG_DC_FTN_TAB_FG
5. VG_VG_YY_CAP_FG
6. VG_DC_FTN_CAP_FG
7. VG_VH_VH_CAP_FG
8. VG_DC_JNB_TAB_FG
9. VG_VG_HP_CAP_FG
10. VG_VG_IS_CAP_FG
[ 31 others ]
248(7.3%)
248(7.3%)
217(6.4%)
186(5.5%)
186(5.5%)
155(4.5%)
155(4.5%)
124(3.6%)
124(3.6%)
124(3.6%)
1643(48.2%)
 19 (0.6%)
15 YEAR [integer]
Mean (sd) : 2021.8 (0.8)
min ≤ med ≤ max:
2021 ≤ 2022 ≤ 2023
IQR (CV) : 1 (0)
2021:1320(38.5%)
2022:1332(38.8%)
2023:777(22.7%)
 0 (0.0%)
16 MONTH [integer]
Mean (sd) : 5.9 (3.3)
min ≤ med ≤ max:
1 ≤ 6 ≤ 12
IQR (CV) : 6 (0.6)
 12 distinct values 0 (0.0%)
17 MONTH_ABBR [character]
1. Apr
2. Feb
3. Jan
4. Jul
5. Jun
6. Mar
7. May
8. Aug
9. Dec
10. Nov
[ 2 others ]
332(9.7%)
332(9.7%)
332(9.7%)
332(9.7%)
332(9.7%)
332(9.7%)
332(9.7%)
221(6.4%)
221(6.4%)
221(6.4%)
442(12.9%)
 0 (0.0%)